Various errors can occur when user IDs of the owner and the user of the SAS Visual Analytics Services database do not match. This mismatch can occur in the following scenario:

1. When SAS^® 9.4 is installed and configured originally, user ID X is specified for the SAS Visual Analytics Services database owner/user.
2. Then, when SAS Visual Analytics is added as an add-on product, user ID Y is specified for the SAS Visual Analytics Services database user.

The result of this mismatch in IDs is that the tables in transportsvcs.db are still owned by user ID X.

In this scenario, the following errors can occur:

• When you select Tools ► Manage Devices in the SAS^® Visual Analytics Administrator, dialog boxes might appear with the following errors:
  

  Returning the whitelist failed.
  Returning the logon records failed.
  Returning the blacklist history failed.
  Returning the blacklist failed.
  

  If you select the option to view the details in the dialog box, you see the following:

  An error has occurred. For details, see the transport service log.
• The transport service log file, SASVisualAnalyticsTransport6.3.log, shows the following error:
  

  com.sas.onebi.transportservices.LogonService - Error processing logon - user:
  cetsas1
  com.sas.onebi.ws.transportservices.client.ServiceExceptionHolder: Error reading
  the blacklist table.
  . . .more statements . . .
  Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
  bad SQL grammar [SELECT * FROM blacklist]; nested exception is
  org.postgresql.util.PSQLException: ERROR: permission denied for relation
  blacklist at 
  . . .more statements . . .

• The PostgreSQL log file, postgresql-*.log, contains the following error:
  
  ESTERROR: permission denied for relation blacklist

In addition, if you attempt to make a connection from a mobile device (such as an Android device), the following error might occur:


Failed to connect to the server. Error: The user ID or password that you
entered is incorrect. Enter a valid user ID and password.

To correct this error, use a PostgreSQL REASSIGN command, as follows, to change the ownership from the existing SAS Visual Analytics Services database owner/user to the new SAS Visual Analytics Services database user who is specified during the add-on process.

1. Connect to the database by submitting the following command from the pgsql command line:
   < psql -h WIP-database-server-hostname.xxx.xxx.com -p WIP-database-server-port -U WIP-database-server-admin -d transportsvcs_db
2. Confirm the table owner by submitting the following command:
   
   # \dt

   This command lists the tables and the owner, as shown in the following example:

               List of relations
    Schema |      Name      | Type  |  Owner
   --------+----------------+-------+---------
    public | blacklist      | table |   X
    public | blacklistaudit | table |   X
    public | logon          | table |   X
    public | qcache         | table |   X
    public | resourceid     | table |   X
    public | whitelist      | table |   X
   (6 rows)
   

3. Resassign table ownership by using the REASSIGN command. In this example, ownership is reassigned from user X to user Y:
   
   # reassign owned by original-database-user to user-added-in-add-on

   In this command:

   • original-database-user specifies the SAS Visual Analytics user who is specified in the original deployment.
   • user-added-in-add-on specifies the user who is added when SAS Visual Analytics is added as an add-on product.
4. Confirm that ownership has changed by listing tables again:
   # \dt

   The new listing should look similar to this following table:

               List of relations
    Schema |      Name      | Type  |  Owner
   --------+----------------+-------+----------
    public | blacklist      | table |    Y
    public | blacklistaudit | table |    Y
    public | logon          | table |    Y
    public | qcache         | table |    Y
    public | resourceid     | table |    Y
    public | whitelist      | table |    Y
   (6 rows)

5. Quit the pgsql command line by submitting this command:
   
   # \q

After performing these steps, you should be able to access Tools ► Mobile Devices in SAS Visual Analytics Administrator and make a connection on a mobile device.





Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Microsoft® Windows® for x64	6.3	6.4	9.4 TS1M1	9.4 TS1M1
		Linux for x64	6.3	6.4	9.4 TS1M1	9.4 TS1M1

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.